Deskdrop is an internal communications platform developed by CI&T, focused in companies using Google G Suite. Among other features, this platform allows companies employees to share relevant articles with their peers, and collaborate around them.
libraries used in the data set.
library(ggplot2)
library(plotly)
library(data.table)
Reading the data into r
users_interactions<-fread("users_intractions_format.csv")
shared_articles <- fread("shared_articles_format.csv")
converting the timestamp colum to date time column in r
#strptime("2016-03-29 00:49:39",f)
users_interactions$timestamp<-as.POSIXct(strptime(users_interactions$timestamp, "%Y-%m-%d %H:%M:%S"))
shared_articles$timestamp<-as.POSIXct(strptime(shared_articles$timestamp,"%Y-%m-%d %H:%M:%S"))
users_interactions[rev(order(timestamp)),]
shared_articles[order(timestamp),]
EDA on user intraction
length(unique(users_interactions$userRegion))
[1] 72
There 72 cities log data of user interactions.
unique(users_interactions$userCountry)
[1] "" "US" "BR" "JP" "KR" "IN" "IE" "SG" "DE" "CA" "IS" "AU" "ZZ" "ES" "CN" "GB" "MY" "AR" "NL" "CL"
[21] "IT" "CO" "PT" "CH"
Total we have 23 countries.
LS0tDQp0aXRsZTogIkFydGljYWxfc2hhcmluZ19FREEiDQpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sNCi0tLQ0KDQpEZXNrZHJvcCBpcyBhbiBpbnRlcm5hbCBjb21tdW5pY2F0aW9ucyBwbGF0Zm9ybSBkZXZlbG9wZWQgYnkgQ0kmVCwgZm9jdXNlZCBpbiBjb21wYW5pZXMgdXNpbmcgR29vZ2xlIEcgU3VpdGUuIEFtb25nIG90aGVyIGZlYXR1cmVzLCB0aGlzIHBsYXRmb3JtIGFsbG93cyBjb21wYW5pZXMgZW1wbG95ZWVzIHRvIHNoYXJlIHJlbGV2YW50IGFydGljbGVzIHdpdGggdGhlaXIgcGVlcnMsIGFuZCBjb2xsYWJvcmF0ZSBhcm91bmQgdGhlbS4NCg0KbGlicmFyaWVzIHVzZWQgaW4gdGhlIGRhdGEgc2V0Lg0KYGBge3J9DQpsaWJyYXJ5KGdncGxvdDIpDQpsaWJyYXJ5KHBsb3RseSkNCmxpYnJhcnkoZGF0YS50YWJsZSkNCmBgYA0KDQpSZWFkaW5nIHRoZSBkYXRhIGludG8gcg0KYGBge3J9DQp1c2Vyc19pbnRlcmFjdGlvbnM8LWZyZWFkKCJ1c2Vyc19pbnRyYWN0aW9uc19mb3JtYXQuY3N2IikNCnNoYXJlZF9hcnRpY2xlcyA8LSBmcmVhZCgic2hhcmVkX2FydGljbGVzX2Zvcm1hdC5jc3YiKQ0KYGBgDQoNCmNvbnZlcnRpbmcgdGhlIHRpbWVzdGFtcCBjb2x1bSB0byBkYXRlIHRpbWUgY29sdW1uIGluIHINCmBgYHtyfQ0KI3N0cnB0aW1lKCIyMDE2LTAzLTI5IDAwOjQ5OjM5IixmKQ0KdXNlcnNfaW50ZXJhY3Rpb25zJHRpbWVzdGFtcDwtYXMuUE9TSVhjdChzdHJwdGltZSh1c2Vyc19pbnRlcmFjdGlvbnMkdGltZXN0YW1wLCAiJVktJW0tJWQgJUg6JU06JVMiKSkNCnNoYXJlZF9hcnRpY2xlcyR0aW1lc3RhbXA8LWFzLlBPU0lYY3Qoc3RycHRpbWUoc2hhcmVkX2FydGljbGVzJHRpbWVzdGFtcCwiJVktJW0tJWQgJUg6JU06JVMiKSkNCmBgYA0KDQpgYGB7cn0NCnVzZXJzX2ludGVyYWN0aW9uc1tyZXYob3JkZXIodGltZXN0YW1wKSksXQ0KYGBgDQoNCmBgYHtyfQ0Kc2hhcmVkX2FydGljbGVzW29yZGVyKHRpbWVzdGFtcCksXQ0KYGBgDQoNCkVEQSBvbiB1c2VyIGludHJhY3Rpb24NCg0KYGBge3J9DQpsZW5ndGgodW5pcXVlKHVzZXJzX2ludGVyYWN0aW9ucyR1c2VyUmVnaW9uKSkNCmBgYA0KVGhlcmUgNzIgY2l0aWVzIGxvZyBkYXRhIG9mIHVzZXIgaW50ZXJhY3Rpb25zLg0KDQoNCmBgYHtyfQ0KdW5pcXVlKHVzZXJzX2ludGVyYWN0aW9ucyR1c2VyQ291bnRyeSkNCmBgYA0KVG90YWwgd2UgaGF2ZSAyMyBjb3VudHJpZXMuDQoNCmBgYHtyfQ0KDQpgYGANCg0KDQoNCg0K